UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sA4knXZAiMqCcsxobRoZaOYcuPa+CgjdP5H9JtKsMko='
WHERE
key_id = 'f1214e528876e43b2009af55414ce94b0727998bd8175595ea9b64a14e54eaee'
AND (
token = 'sA4knXZAiMqCcsxobRoZaOYcuPa+CgjdP5H9JtKsMko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)