UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jT+XKNkG0nQd4JgTNS8LI8pnpn888CPHBU+KGTwecbQ='
WHERE
key_id = '673854c5409e8cd039a27f504dc03e910e500179037bdf9b6b16e882a8cb8666'
AND (
token = 'jT+XKNkG0nQd4JgTNS8LI8pnpn888CPHBU+KGTwecbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)