UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4BroRQPrhRpkNu5yMc/46shm1by/DDXZKeV3dAwYnHs='
WHERE
key_id = '1a562f2480187f850a06039824e8b97cc4ea8850dfee9a5d1df78842e84e7721'
AND (
token = '4BroRQPrhRpkNu5yMc/46shm1by/DDXZKeV3dAwYnHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)