UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TktUTtTq3aRYtGo+WBQnvIS1mswA+6TZm76p8eUSV1Y='
WHERE
key_id = '9058f6b5964d570c57034ad5e7f961b4aa1ff91337903e2001e941ad8f957519'
AND (
token = 'TktUTtTq3aRYtGo+WBQnvIS1mswA+6TZm76p8eUSV1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)