UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RKNj1M1MopBNh2CIjRyeFWMjt7kbmR/Esr923W5zPt4='
WHERE
key_id = '199cc8f554f8170e8bb84f14b162c5cef8dee758d5e9c3ef0213683661cb0cfc'
AND (
token = 'RKNj1M1MopBNh2CIjRyeFWMjt7kbmR/Esr923W5zPt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)