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