UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ljJ+3yFbGPe1uiIo8+VI5uuvi9hgpum4DaOzrPuz2Y='
WHERE
key_id = 'c07d7eb33f59760bcba4195828052441b60ebd970418c576c8a682f57353c75d'
AND (
token = '7ljJ+3yFbGPe1uiIo8+VI5uuvi9hgpum4DaOzrPuz2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)