UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/NSYC0G3crzgPI6A48AdMkTb+ctF9MW/x6K5Dyr0sQ8='
WHERE
key_id = '94a11ba75b126b16f146a814be9da2fe481fc52e2f415a5f0c47cd2dd10a8964'
AND (
token = '/NSYC0G3crzgPI6A48AdMkTb+ctF9MW/x6K5Dyr0sQ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)