UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMxx9TRaj5t+VWQmhA4CWbVBE6cd+9rWSs5OpRceEqo='
WHERE
key_id = '88cd12808de3ab567fe1f8518676fdd9e410d51ab650057112926171e25eecfc'
AND (
token = 'BMxx9TRaj5t+VWQmhA4CWbVBE6cd+9rWSs5OpRceEqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)