UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b1bOa/8I5OdO7i3Janqc8t8Klwfv4FHKMioThmJIiV0='
WHERE
key_id = '2cfb48f731094025f54b704682cb13c84767c56ba5b04f339eeac2fbb45b1f7e'
AND (
token = 'b1bOa/8I5OdO7i3Janqc8t8Klwfv4FHKMioThmJIiV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)