UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lvMWV+l5YpvQAChzmIys2i7fXdF+5tec4oWKyIa6AuI='
WHERE
key_id = '480bf81690710de797247150c2c16b8af7002d7feff5732b0a5de13fcb031bab'
AND (
token = 'lvMWV+l5YpvQAChzmIys2i7fXdF+5tec4oWKyIa6AuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)