UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c8HDgm4NfDuqZTd7gz2NvylFKNOLK1n6vzcDaXJPVWc='
WHERE
key_id = 'f41b89ff1a2c14b41dcfd47789e12b9b04d4b062baa4251a8f3a258f83a6e5d3'
AND (
token = 'c8HDgm4NfDuqZTd7gz2NvylFKNOLK1n6vzcDaXJPVWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)