UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SnI7RfNphGMyjjeNcdzZ9vxNI6qKfjNrknhgJJ5iRGA='
WHERE
key_id = '5aa3728c29e41221f0e2f566e4fff61fdc9a8d3bd535b52079deb1b5f62f276f'
AND (
token = 'SnI7RfNphGMyjjeNcdzZ9vxNI6qKfjNrknhgJJ5iRGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)