UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CXX/StsotcKFIMNQWpnpcAAH25ZD9sdRKDZ6MSzMR4A='
WHERE
key_id = 'd104133ec4f5c10272e4051c14f1e389b3772d08bdedcc4651935ece17e53a37'
AND (
token = 'CXX/StsotcKFIMNQWpnpcAAH25ZD9sdRKDZ6MSzMR4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)