UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YWgueN/GkJV/pae4jh0+oJbkX09rKoPY0Vl3MDIMmws='
WHERE
key_id = 'd57c7d8e8345b9210a883e01afa2f19de4b0cddf53e29d7fd8f0f1d61e38068e'
AND (
token = 'YWgueN/GkJV/pae4jh0+oJbkX09rKoPY0Vl3MDIMmws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)