UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4SWSUfpQ250cRnJvpe0pX4uOo8UPQoHADMVDAH8JQoo='
WHERE
key_id = 'f997717dea26be5102da733e4baf14363e56a3adc2ae4d46f8a11424a565b196'
AND (
token = '4SWSUfpQ250cRnJvpe0pX4uOo8UPQoHADMVDAH8JQoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)