UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqcvS4v37DVIh/apIARD2V1tYrYTsgsmJIig08ND0EM='
WHERE
key_id = '5f1910edd75b21ec8b4a4af3a8068ab264d6e5837a6b82b944125a0a542bb9fd'
AND (
token = 'zqcvS4v37DVIh/apIARD2V1tYrYTsgsmJIig08ND0EM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)