UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RCOsRP7oaSsMdr/3jT8F7Z4mmNDsgzH6KkDhFPhuK1I='
WHERE
key_id = 'e1860c7b334d7631f6ed85468e339878a546899cfbe89e36a58a303b11945feb'
AND (
token = 'RCOsRP7oaSsMdr/3jT8F7Z4mmNDsgzH6KkDhFPhuK1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)