UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgQqsBQomyzt6+RzYfh54pijpAX+6f4v0nLFJPBeef8='
WHERE
key_id = '82631c6fba4a909f0609f54ef08565b4f001dd877a2e68b9eab78e0955099413'
AND (
token = 'BgQqsBQomyzt6+RzYfh54pijpAX+6f4v0nLFJPBeef8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)