UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TaCcgVeiMXM6TK8igis5k4VsatlLZwiR+pgYVM17YEg='
WHERE
key_id = '336c72ad82b07c5972a32e9d9a4e9a29c4aafa2adb40f9a2462003de52007217'
AND (
token = 'TaCcgVeiMXM6TK8igis5k4VsatlLZwiR+pgYVM17YEg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)