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