UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oAHaSknEsZkqDTBT+htaBZ3RH2XNVOMH5+b2XlC7II8='
WHERE
key_id = '20c997e93952e87d8ab76026e9543a53dcf75b65cfd14e199e494a483a4a087b'
AND (
token = 'oAHaSknEsZkqDTBT+htaBZ3RH2XNVOMH5+b2XlC7II8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)