UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pH5bcmGAjcr0e0YoX002af8Eh/RfwRjZl7d/6ce5qjI='
WHERE
key_id = 'b47afd04350d7e72830682f34dda905588f5816acca11b82369e4934181c56dd'
AND (
token = 'pH5bcmGAjcr0e0YoX002af8Eh/RfwRjZl7d/6ce5qjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)