UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g8bNZ/T+W6SeEp/w9bo36w67nkddqASH/9CKFSaGYlA='
WHERE
key_id = 'abff7f97a001ff691be02a3364a7ec5d4d9e670b974864f44c78f53b3fd3ffe3'
AND (
token = 'g8bNZ/T+W6SeEp/w9bo36w67nkddqASH/9CKFSaGYlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)