UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fhMN/d7DcFq9q/UBbufuZ3PKKlpBK21bhSE85iDcmX0='
WHERE
key_id = 'fdc2758b4a3ae1e137bd15c347a163ed6e0e6b4d313f71eb0df24acbf9e0cf14'
AND (
token = 'fhMN/d7DcFq9q/UBbufuZ3PKKlpBK21bhSE85iDcmX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)