UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xwl8wjG/ZOjLDrPtnd5Lt9uvVdPmEUtBiYJrT+2hvlo='
WHERE
key_id = 'a797d9cd1d35b43cf2b6b5416d567c2f775c63f42a4f1db05db6ae6902876f29'
AND (
token = 'xwl8wjG/ZOjLDrPtnd5Lt9uvVdPmEUtBiYJrT+2hvlo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)