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