UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fKOpGGUemeVSJMXmchvbCfuhhrnqHiQuOaBiIbfx7aI='
WHERE
key_id = '170b8b9574511431b96ace01055369e51df194a821524c9f7b0e91dfbbc5fcea'
AND (
token = 'fKOpGGUemeVSJMXmchvbCfuhhrnqHiQuOaBiIbfx7aI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)