UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TJ4pv0tdiW+8Av1FKfsZXsIILupcAU7r8PlbKaMdhHg='
WHERE
key_id = '2c45970f3c802968232d83f11e1bef7cae5df127b181bc2c848f82aaba946da2'
AND (
token = 'TJ4pv0tdiW+8Av1FKfsZXsIILupcAU7r8PlbKaMdhHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)