UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'asVzn7lmozc6qOtvMMKHe02pkXPS1J9wf/aUHRbi9pk='
WHERE
key_id = '55444b8a41241d5aece60bcee9aefeffce4c97a726405d2af6734214de1cd6c0'
AND (
token = 'asVzn7lmozc6qOtvMMKHe02pkXPS1J9wf/aUHRbi9pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)